package cn.lili.modules.store.mapper;

import cn.lili.modules.store.entity.dos.StoreSft;
import cn.lili.modules.store.entity.dos.StoreZft;
import cn.lili.modules.store.entity.vos.StoreSftVO;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface StoreSftMapper extends BaseMapper<StoreSft> {

    @Select("select s.*,d.* from li_store_sft s inner join li_store d on d.id=s.store_id where s.id=#{id} ")
    StoreSftVO getDetail(String id);

    @Select("select s.*,d.store_name from li_store_sft as s inner join li_store d on d.id=s.store_id ${ew.customSqlSegment}")
    IPage<StoreSftVO> getList(IPage<StoreSftVO> page, @Param(Constants.WRAPPER) Wrapper<StoreSftVO> queryWrapper);
}
